CSV

You can import metadata from CSV files into a CSV environment.

To import metadata from CSV files, follow these steps:

  1. On the Explore tab, click a CSV environment tile to view its details.
    Alternatively, under Filter By Database Type, select the CSV option to view all CSV environments.
  2. Click Options.
    The available options appear.
  3. Click Scan Metadata.

    4. The CSV Metadata Scan - Step1 page appears.

  4. Drag and drop or use to browse and select the delimiter file.
  5. In the File Path(s) box, enter the file path.
  6. Use the following scan options:
    Add New
    Use this option to insert new metadata into the environment.
    Update Existing + Add New
    Use this option to update the existing metadata based on the table and columns in the CSV file.
    Update Existing + Add New + Invalidate
    Use this option to update the existing metadata without deleting it.
    Delete & Reload
    Use this option to delete all the business properties and data dictionary stored as metadata for this environment.
    Import Comments
    Use this option to import column-level comments from the CSV file into metadata.
    Skip Empty Cells
    Use this option to skip blank cells in the CSV file to avoid overwriting existing metadata with empty values. This option is available only when you select the Update Existing + Add New or Update Existing + Add New + Invalidate options.
  7. Click .

    8. The CSV Metadata Scan - Step2 page appears.

  8. Select the required tables.
  9. Click .

    10. The metadata is imported and saved in the environment.